How to: Make format of a selected chart the default chart format in Excel.
Solution:
Select the chart, select 'Options...' from the 'Tools' menu, click the 'Chart' tab, and click 'Use Current Chart'.
1) Select the chart:
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
3) Click 'Chart' tab.
4) Click 'Use The Current Chart...'. (The Add Custom AutoFormat dialog box appears.)
Add Custom AutoFormat box
5) Type a name for the current chart format in the 'Format Name' box.
type chart name
6) Click 'OK'. (The Options dialog box reappears with the name of the current chart format in the Default Chart Format drop-down list box.)
7) Click 'OK'.
